package com.yonyou.gmmc.service.information.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.yonyou.gmmc.service.information.annotation.OracleDb;
import com.yonyou.gmmc.service.information.model.TmExamineCarResult;
import tk.mybatis.mapper.common.Mapper;

@OracleDb
public interface TmExamineCarResultMapper extends Mapper<TmExamineCarResult> {

	List<Map<String, Object>> acquireSeries();

	List<Map<String, Object>> acquireModel(Integer seriesId);

	List<Map<String, Object>> acquireMileage();

	List<TmExamineCarResult> acquireResult(Integer monthResultId);

	List<Integer> queryAllMonth();

	Integer queryMonthResultId(@Param("modelId") Integer modelId,@Param("maxMonth") Integer maxMonth);

	Integer queryMileageResultId(@Param("modelId") Integer modelId,@Param("travelMileage")Integer travelMileage);
}